﻿-- =============================================
-- Script Template
-- =============================================


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Ivy_Sys_RoleMaster]'
GO

SET IDENTITY_INSERT [Sys_RoleMaster] ON
INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'SYSSPRADM', N'System Super Admin', N'Super Administrator for the Website/Portal', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'SYSADMIN', N'System Admin', N'Administrator for the Website/Portal', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'SYSOPRAT', N'System Operator', N'Operator for the Website/Portal', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'SYSREGUSR', N'System Registered User', N'User registered with the Website/Portal', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'SCTSUPADM', N'Society Super Admin', N'Super Administrator for the Society related operations', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'SCTADMIN', N'Society Portal Admin', N'Administrator for the Society, a member of Management Committee', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'SCTOPRAT', N'Society Portal Operator', N'Portal Operator for the Society, mostly employees of the society', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'SCTEMPLY', N'Society Employee', N'Transactional Data Operator for the Society, mostly employees of the society', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, N'SCTFLTOWN', N'Society Flat Owner', N'Flat Owner of a Society', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, N'SCTFLTRES', N'Society Resident', N'Resident of a Flat of a Society', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (11, N'APTBLDR', N'Apartment Builder', N'Builder of the Apartment complex', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (12, N'LOCVENDOR', N'Vendor', N'Local Vendor/Suplier/Service provider', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

SET IDENTITY_INSERT [Sys_RoleMaster] OFF
		